**Pranav Dange**
| Province/State | Country/Region | Lat | Long | 1/22/20 | 1/23/20 | 1/24/20 | 1/25/20 | 1/26/20 | 1/27/20 | ... | 2/28/21 | 3/1/21 | 3/2/21 | 3/3/21 | 3/4/21 | 3/5/21 | 3/6/21 | 3/7/21 | 3/8/21 | 3/9/21 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | NaN | Afghanistan | 33.93911 | 67.709953 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 2443 | 2444 | 2446 | 2446 | 2446 | 2449 | 2449 | 2449 | 2451 | 2451 |
| 1 | NaN | Albania | 41.15330 | 20.168300 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 1796 | 1816 | 1835 | 1856 | 1876 | 1897 | 1918 | 1939 | 1956 | 1969 |
| 2 | NaN | Algeria | 28.03390 | 1.659600 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 2983 | 2987 | 2991 | 2996 | 3002 | 3007 | 3010 | 3013 | 3018 | 3022 |
| 3 | NaN | Andorra | 42.50630 | 1.521800 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 110 | 110 | 110 | 112 | 112 | 112 | 112 | 112 | 112 | 112 |
| 4 | NaN | Angola | -11.20270 | 17.873900 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 508 | 508 | 510 | 510 | 511 | 511 | 512 | 514 | 515 | 516 |
| 5 | NaN | Antigua and Barbuda | 17.06080 | -61.796400 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 14 | 14 | 14 | 19 | 21 | 21 | 21 | 21 | 21 | 22 |
| 6 | NaN | Argentina | -38.41610 | -63.616700 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 51965 | 52077 | 52192 | 52453 | 52644 | 52784 | 52870 | 52880 | 53121 | 53252 |
| 7 | NaN | Armenia | 40.06910 | 45.038200 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 3192 | 3195 | 3200 | 3202 | 3208 | 3215 | 3219 | 3221 | 3225 | 3232 |
| 8 | Australian Capital Territory | Australia | -35.47350 | 149.012400 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 |
| 9 | New South Wales | Australia | -33.86880 | 151.209300 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 |
10 rows × 417 columns
| Province/State | Country/Region | Lat | Long | 1/22/20 | 1/23/20 | 1/24/20 | 1/25/20 | 1/26/20 | 1/27/20 | ... | 2/28/21 | 3/1/21 | 3/2/21 | 3/3/21 | 3/4/21 | 3/5/21 | 3/6/21 | 3/7/21 | 3/8/21 | 3/9/21 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | NaN | Afghanistan | 33.93911 | 67.709953 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 55714 | 55733 | 55759 | 55770 | 55775 | 55827 | 55840 | 55847 | 55876 | 55876 |
| 1 | NaN | Albania | 41.15330 | 20.168300 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 107167 | 107931 | 108823 | 109674 | 110521 | 111301 | 112078 | 112897 | 113580 | 114209 |
| 2 | NaN | Algeria | 28.03390 | 1.659600 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 113092 | 113255 | 113430 | 113593 | 113761 | 113948 | 114104 | 114234 | 114382 | 114543 |
| 3 | NaN | Andorra | 42.50630 | 1.521800 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 10866 | 10889 | 10908 | 10948 | 10976 | 10998 | 11019 | 11042 | 11069 | 11089 |
| 4 | NaN | Angola | -11.20270 | 17.873900 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 20807 | 20854 | 20882 | 20923 | 20981 | 21026 | 21055 | 21086 | 21108 | 21114 |
5 rows × 417 columns
| Province/State | Country/Region | Lat | Long | 1/22/20 | 1/23/20 | 1/24/20 | 1/25/20 | 1/26/20 | 1/27/20 | ... | 2/28/21 | 3/1/21 | 3/2/21 | 3/3/21 | 3/4/21 | 3/5/21 | 3/6/21 | 3/7/21 | 3/8/21 | 3/9/21 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | NaN | Afghanistan | 33.93911 | 67.709953 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 49333 | 49344 | 49347 | 49359 | 49362 | 49362 | 49369 | 49378 | 49402 | 49409 |
| 1 | NaN | Albania | 41.15330 | 20.168300 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 69773 | 70413 | 71173 | 72076 | 72853 | 73610 | 74352 | 75190 | 75887 | 76784 |
| 2 | NaN | Algeria | 28.03390 | 1.659600 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 78098 | 78234 | 78377 | 78524 | 78672 | 78824 | 78946 | 79064 | 79187 | 79319 |
| 3 | NaN | Andorra | 42.50630 | 1.521800 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 10446 | 10475 | 10501 | 10560 | 10564 | 10584 | 10599 | 10626 | 10661 | 10685 |
| 4 | NaN | Angola | -11.20270 | 17.873900 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 19322 | 19400 | 19410 | 19509 | 19553 | 19624 | 19640 | 19647 | 19657 | 19677 |
5 rows × 417 columns
| Lat | Long | 1/22/20 | 1/23/20 | 1/24/20 | 1/25/20 | 1/26/20 | 1/27/20 | 1/28/20 | 1/29/20 | ... | 2/28/21 | 3/1/21 | 3/2/21 | 3/3/21 | 3/4/21 | 3/5/21 | 3/6/21 | 3/7/21 | 3/8/21 | 3/9/21 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| count | 259.000000 | 259.000000 | 259.000000 | 259.000000 | 259.000000 | 259.000000 | 259.000000 | 259.000000 | 259.000000 | 259.000000 | ... | 2.590000e+02 | 2.590000e+02 | 2.590000e+02 | 2.590000e+02 | 2.590000e+02 | 2.590000e+02 | 2.590000e+02 | 2.590000e+02 | 2.590000e+02 | 2.590000e+02 |
| mean | 19.102739 | 28.495821 | 0.115830 | 0.123552 | 0.150579 | 0.162162 | 0.216216 | 0.250965 | 0.416988 | 0.490347 | ... | 2.487199e+05 | 2.495497e+05 | 2.505926e+05 | 2.514784e+05 | 2.524447e+05 | 2.533187e+05 | 2.542318e+05 | 2.551520e+05 | 2.562120e+05 | 2.572245e+05 |
| std | 24.640880 | 70.936043 | 1.743788 | 1.747697 | 1.940118 | 2.005022 | 2.641273 | 2.839838 | 5.005023 | 5.505010 | ... | 9.830249e+05 | 9.861209e+05 | 9.899560e+05 | 9.928190e+05 | 9.962596e+05 | 9.991093e+05 | 1.001900e+06 | 1.005128e+06 | 1.009698e+06 | 1.013200e+06 |
| min | -51.796300 | -178.116500 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | ... | 0.000000e+00 | 0.000000e+00 | 0.000000e+00 | 0.000000e+00 | 0.000000e+00 | 0.000000e+00 | 0.000000e+00 | 0.000000e+00 | 0.000000e+00 | 0.000000e+00 |
| 25% | 4.715658 | -8.826999 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | ... | 8.095000e+02 | 8.095000e+02 | 8.095000e+02 | 8.095000e+02 | 8.095000e+02 | 8.095000e+02 | 8.095000e+02 | 8.095000e+02 | 8.095000e+02 | 8.095000e+02 |
| 50% | 19.856270 | 24.603200 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | ... | 8.406000e+03 | 8.413000e+03 | 8.426000e+03 | 8.439000e+03 | 8.450000e+03 | 8.456000e+03 | 8.464000e+03 | 8.469000e+03 | 8.473000e+03 | 8.487000e+03 |
| 75% | 39.018950 | 90.394950 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | ... | 1.319695e+05 | 1.321660e+05 | 1.324985e+05 | 1.328205e+05 | 1.332625e+05 | 1.334725e+05 | 1.337125e+05 | 1.343540e+05 | 1.347615e+05 | 1.351970e+05 |
| max | 71.706900 | 178.065000 | 28.000000 | 28.000000 | 31.000000 | 32.000000 | 42.000000 | 45.000000 | 80.000000 | 88.000000 | ... | 1.078645e+07 | 1.079892e+07 | 1.081204e+07 | 1.082608e+07 | 1.083989e+07 | 1.085413e+07 | 1.086852e+07 | 1.088280e+07 | 1.089939e+07 | 1.092005e+07 |
8 rows × 415 columns
| Country_Region | Last_Update | Lat | Long_ | Confirmed | Deaths | Recovered | Active | Incident_Rate | People_Tested | People_Hospitalized | Mortality_Rate | UID | ISO3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Afghanistan | 2021-03-10 11:23:13 | 33.93911 | 67.709953 | 55894.0 | 2451.0 | 49499.0 | 3944.0 | 143.581767 | NaN | NaN | 4.385086 | 4 | AFG |
| 1 | Albania | 2021-03-10 11:23:13 | 41.15330 | 20.168300 | 114209.0 | 1969.0 | 76784.0 | 35456.0 | 3968.621864 | NaN | NaN | 1.724032 | 8 | ALB |
| 2 | Algeria | 2021-03-10 11:23:13 | 28.03390 | 1.659600 | 114543.0 | 3022.0 | 79319.0 | 32202.0 | 261.209294 | NaN | NaN | 2.638311 | 12 | DZA |
| 3 | Andorra | 2021-03-10 11:23:13 | 42.50630 | 1.521800 | 11089.0 | 112.0 | 10685.0 | 292.0 | 14351.905779 | NaN | NaN | 1.010010 | 20 | AND |
| 4 | Angola | 2021-03-10 11:23:13 | -11.20270 | 17.873900 | 21114.0 | 516.0 | 19677.0 | 921.0 | 64.242159 | NaN | NaN | 2.443876 | 24 | AGO |
| country | Last_Update | Lat | Long_ | Confirmed | Deaths | Recovered | Active | Incident_Rate | People_Tested | People_Hospitalized | Mortality_Rate | UID | ISO3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Afghanistan | 2021-03-10 11:23:13 | 33.93911 | 67.709953 | 55894.0 | 2451.0 | 49499.0 | 3944.0 | 143.581767 | NaN | NaN | 4.385086 | 4 | AFG |
| 1 | Albania | 2021-03-10 11:23:13 | 41.15330 | 20.168300 | 114209.0 | 1969.0 | 76784.0 | 35456.0 | 3968.621864 | NaN | NaN | 1.724032 | 8 | ALB |
| 2 | Algeria | 2021-03-10 11:23:13 | 28.03390 | 1.659600 | 114543.0 | 3022.0 | 79319.0 | 32202.0 | 261.209294 | NaN | NaN | 2.638311 | 12 | DZA |
| 3 | Andorra | 2021-03-10 11:23:13 | 42.50630 | 1.521800 | 11089.0 | 112.0 | 10685.0 | 292.0 | 14351.905779 | NaN | NaN | 1.010010 | 20 | AND |
| 4 | Angola | 2021-03-10 11:23:13 | -11.20270 | 17.873900 | 21114.0 | 516.0 | 19677.0 | 921.0 | 64.242159 | NaN | NaN | 2.443876 | 24 | AGO |
117644542
2612176
66679837
19783893
Index(['state', 'country', 'Lat', 'Long', '1/22/20', '1/23/20', '1/24/20',
'1/25/20', '1/26/20', '1/27/20',
...
'2/28/21', '3/1/21', '3/2/21', '3/3/21', '3/4/21', '3/5/21', '3/6/21',
'3/7/21', '3/8/21', '3/9/21'],
dtype='object', length=417)
Index(['state', 'country', 'Lat', 'Long', '1/22/20', '1/23/20', '1/24/20',
'1/25/20', '1/26/20', '1/27/20',
...
'2/28/21', '3/1/21', '3/2/21', '3/3/21', '3/4/21', '3/5/21', '3/6/21',
'3/7/21', '3/8/21', '3/9/21'],
dtype='object', length=417)
Index(['state', 'country', 'Lat', 'Long', '1/22/20', '1/23/20', '1/24/20',
'1/25/20', '1/26/20', '1/27/20',
...
'2/28/21', '3/1/21', '3/2/21', '3/3/21', '3/4/21', '3/5/21', '3/6/21',
'3/7/21', '3/8/21', '3/9/21'],
dtype='object', length=417)
117557794 2610184 117557807
MAE: 7793076.198382464 MSE: 78178532830879.94 [[ 1.25151877e+07 -4.76549318e+05 6.33808777e+03 -3.33307375e+01 8.82039658e-02 -8.17240325e-05]]
0.9994807262436223